[ROOT] dt FactResellerSale < WHERE DimResellerId EQ '586' >
47 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO48337_1 | BE13-436F-B5 | PO11165163196 | 19 | 291 | 360 | 586 | 6 | 2022-09-15 | 4917.84 | 122.95 | 2022-09-03 | 4 | 1105.81 | 1 | 4917.84 | 1 | SO48337 | 2022-09-10 | 393.43 | 4423.24 | 1229.46 | |||
SO48337_2 | BE13-436F-B5 | PO11165163196 | 19 | 291 | 354 | 586 | 6 | 2022-09-15 | 1242.85 | 31.07 | 2022-09-03 | 1 | 1117.86 | 1 | 1242.85 | 2 | SO48337 | 2022-09-10 | 99.43 | 1117.86 | 1242.85 | |||
SO48337_3 | BE13-436F-B5 | PO11165163196 | 19 | 291 | 358 | 586 | 6 | 2022-09-15 | 6147.29 | 153.68 | 2022-09-03 | 5 | 1105.81 | 1 | 6147.29 | 3 | SO48337 | 2022-09-10 | 491.78 | 5529.05 | 1229.46 | |||
SO48337_4 | BE13-436F-B5 | PO11165163196 | 19 | 291 | 470 | 586 | 6 | 2022-09-15 | 136.76 | 3.42 | 2022-09-03 | 6 | 15.67 | 1 | 136.76 | 4 | SO48337 | 2022-09-10 | 10.94 | 94.03 | 22.79 | |||
SO48337_5 | BE13-436F-B5 | PO11165163196 | 19 | 291 | 468 | 586 | 6 | 2022-09-15 | 68.38 | 1.71 | 2022-09-03 | 3 | 15.67 | 1 | 68.38 | 5 | SO48337 | 2022-09-10 | 5.47 | 47.01 | 22.79 | |||
SO48337_6 | BE13-436F-B5 | PO11165163196 | 19 | 291 | 469 | 586 | 6 | 2022-09-15 | 136.76 | 3.42 | 2022-09-03 | 6 | 15.67 | 1 | 136.76 | 6 | SO48337 | 2022-09-10 | 10.94 | 94.03 | 22.79 | |||
SO49482_1 | B4B5-4693-83 | PO11165189258 | 19 | 291 | 360 | 586 | 6 | 2022-12-14 | 2458.92 | 61.47 | 2022-12-02 | 2 | 1105.81 | 1 | 2458.92 | 1 | SO49482 | 2022-12-09 | 196.71 | 2211.62 | 1229.46 | |||
SO49482_2 | B4B5-4693-83 | PO11165189258 | 19 | 291 | 468 | 586 | 6 | 2022-12-14 | 22.79 | 0.57 | 2022-12-02 | 1 | 15.67 | 1 | 22.79 | 2 | SO49482 | 2022-12-09 | 1.82 | 15.67 | 22.79 | |||
SO49482_3 | B4B5-4693-83 | PO11165189258 | 19 | 291 | 358 | 586 | 6 | 2022-12-14 | 2458.92 | 61.47 | 2022-12-02 | 2 | 1105.81 | 1 | 2458.92 | 3 | SO49482 | 2022-12-09 | 196.71 | 2211.62 | 1229.46 | |||
SO49482_4 | B4B5-4693-83 | PO11165189258 | 19 | 291 | 470 | 586 | 6 | 2022-12-14 | 45.59 | 1.14 | 2022-12-02 | 2 | 15.67 | 1 | 45.59 | 4 | SO49482 | 2022-12-09 | 3.65 | 31.34 | 22.79 | |||
SO49482_5 | B4B5-4693-83 | PO11165189258 | 19 | 291 | 469 | 586 | 6 | 2022-12-14 | 22.79 | 0.57 | 2022-12-02 | 1 | 15.67 | 1 | 22.79 | 5 | SO49482 | 2022-12-09 | 1.82 | 15.67 | 22.79 | |||
SO50684_1 | 74E9-4949-91 | PO11165153787 | 19 | 291 | 469 | 586 | 6 | 2023-03-16 | 136.76 | 3.42 | 2023-03-04 | 6 | 15.67 | 1 | 136.76 | 1 | SO50684 | 2023-03-11 | 10.94 | 94.03 | 22.79 | |||
SO50684_2 | 74E9-4949-91 | PO11165153787 | 19 | 291 | 468 | 586 | 6 | 2023-03-16 | 68.38 | 1.71 | 2023-03-04 | 3 | 15.67 | 1 | 68.38 | 2 | SO50684 | 2023-03-11 | 5.47 | 47.01 | 22.79 | |||
SO50684_3 | 74E9-4949-91 | PO11165153787 | 19 | 291 | 470 | 586 | 6 | 2023-03-16 | 205.15 | 5.13 | 2023-03-04 | 9 | 15.67 | 1 | 205.15 | 3 | SO50684 | 2023-03-11 | 16.41 | 141.04 | 22.79 | |||
SO50684_4 | 74E9-4949-91 | PO11165153787 | 19 | 291 | 352 | 586 | 6 | 2023-03-16 | 2485.70 | 62.14 | 2023-03-04 | 2 | 1117.86 | 1 | 2485.70 | 4 | SO50684 | 2023-03-11 | 198.86 | 2235.71 | 1242.85 | |||
SO50684_5 | 74E9-4949-91 | PO11165153787 | 19 | 291 | 360 | 586 | 6 | 2023-03-16 | 2458.92 | 61.47 | 2023-03-04 | 2 | 1105.81 | 1 | 2458.92 | 5 | SO50684 | 2023-03-11 | 196.71 | 2211.62 | 1229.46 | |||
SO50684_6 | 74E9-4949-91 | PO11165153787 | 19 | 291 | 358 | 586 | 6 | 2023-03-16 | 2458.92 | 61.47 | 2023-03-04 | 2 | 1105.81 | 1 | 2458.92 | 6 | SO50684 | 2023-03-11 | 196.71 | 2211.62 | 1229.46 | |||
SO47396_1 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 420 | 586 | 6 | 2022-06-16 | 566.46 | 14.16 | 2022-06-04 | 4 | 104.80 | 1 | 566.46 | 1 | SO47396 | 2022-06-11 | 45.32 | 419.18 | 141.62 | |||
SO47396_2 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 356 | 586 | 6 | 2022-06-16 | 2485.70 | 62.14 | 2022-06-04 | 2 | 1117.86 | 1 | 2485.70 | 2 | SO47396 | 2022-06-11 | 198.86 | 2235.71 | 1242.85 | |||
SO47396_3 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 352 | 586 | 6 | 2022-06-16 | 4971.41 | 124.29 | 2022-06-04 | 4 | 1117.86 | 1 | 4971.41 | 3 | SO47396 | 2022-06-11 | 397.71 | 4471.42 | 1242.85 | |||
SO47396_4 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 399 | 586 | 6 | 2022-06-16 | 101.32 | 2.53 | 2022-06-04 | 3 | 24.99 | 1 | 101.32 | 4 | SO47396 | 2022-06-11 | 8.11 | 74.98 | 33.77 | |||
SO47396_5 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 360 | 586 | 6 | 2022-06-16 | 3688.38 | 92.21 | 2022-06-04 | 3 | 1105.81 | 1 | 3688.38 | 5 | SO47396 | 2022-06-11 | 295.07 | 3317.43 | 1229.46 | |||
SO47396_6 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 470 | 586 | 6 | 2022-06-16 | 182.35 | 4.56 | 2022-06-04 | 8 | 15.67 | 1 | 182.35 | 6 | SO47396 | 2022-06-11 | 14.59 | 125.37 | 22.79 | |||
SO47396_7 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 354 | 586 | 6 | 2022-06-16 | 4971.41 | 124.29 | 2022-06-04 | 4 | 1117.86 | 1 | 4971.41 | 7 | SO47396 | 2022-06-11 | 397.71 | 4471.42 | 1242.85 | |||
SO47396_8 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 421 | 586 | 6 | 2022-06-16 | 588.99 | 14.72 | 2022-06-04 | 3 | 145.28 | 1 | 588.99 | 8 | SO47396 | 2022-06-11 | 47.12 | 435.85 | 196.33 | |||
SO47396_9 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 469 | 586 | 6 | 2022-06-16 | 136.76 | 3.42 | 2022-06-04 | 6 | 15.67 | 1 | 136.76 | 9 | SO47396 | 2022-06-11 | 10.94 | 94.03 | 22.79 | |||
SO47396_10 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 428 | 586 | 6 | 2022-06-16 | 418.51 | 10.46 | 2022-06-04 | 2 | 185.82 | 1 | 418.51 | 10 | SO47396 | 2022-06-11 | 33.48 | 371.64 | 209.26 | |||
SO47396_11 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 419 | 586 | 6 | 2022-06-16 | 263.24 | 6.58 | 2022-06-04 | 5 | 38.96 | 1 | 263.24 | 11 | SO47396 | 2022-06-11 | 21.06 | 194.79 | 52.65 | |||
SO47396_12 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 468 | 586 | 6 | 2022-06-16 | 113.97 | 2.85 | 2022-06-04 | 5 | 15.67 | 1 | 113.97 | 12 | SO47396 | 2022-06-11 | 9.12 | 78.35 | 22.79 | |||
SO47396_13 | 6B61-4DD9-AA | PO11165191815 | 19 | 291 | 358 | 586 | 6 | 2022-06-16 | 1229.46 | 30.74 | 2022-06-04 | 1 | 1105.81 | 1 | 1229.46 | 13 | SO47396 | 2022-06-11 | 98.36 | 1105.81 | 1229.46 | |||
SO53503_1 | 3066-4F29-8B | PO11165175744 | 19 | 291 | 475 | 586 | 6 | 2023-06-16 | 167.98 | 4.20 | 2023-06-04 | 4 | 26.18 | 1 | 167.98 | 1 | SO53503 | 2023-06-11 | 13.44 | 104.71 | 41.99 | |||
SO53503_2 | 3066-4F29-8B | PO11165175744 | 19 | 291 | 517 | 586 | 6 | 2023-06-16 | 126.34 | 3.16 | 2023-06-04 | 4 | 23.37 | 1 | 126.34 | 2 | SO53503 | 2023-06-11 | 10.11 | 93.49 | 31.58 | |||
SO53503_3 | 3066-4F29-8B | PO11165175744 | 19 | 291 | 544 | 586 | 6 | 2023-06-16 | 145.78 | 3.64 | 2023-06-04 | 3 | 35.96 | 1 | 145.78 | 3 | SO53503 | 2023-06-11 | 11.66 | 107.88 | 48.59 | |||
SO53503_4 | 3066-4F29-8B | PO11165175744 | 19 | 291 | 474 | 3 | 586 | 6 | 30.80 | 2023-06-16 | 615.91 | 14.63 | 2023-06-04 | 16 | 26.18 | 1 | 585.12 | 4 | SO53503 | 2023-06-11 | 46.81 | 418.82 | 38.49 | 0.05 |
SO53503_5 | 3066-4F29-8B | PO11165175744 | 19 | 291 | 359 | 586 | 6 | 2023-06-16 | 2753.99 | 68.85 | 2023-06-04 | 2 | 1251.98 | 1 | 2753.99 | 5 | SO53503 | 2023-06-11 | 220.32 | 2503.96 | 1376.99 | |||
SO53503_6 | 3066-4F29-8B | PO11165175744 | 19 | 291 | 511 | 586 | 6 | 2023-06-16 | 436.91 | 10.92 | 2023-06-04 | 2 | 199.38 | 1 | 436.91 | 6 | SO53503 | 2023-06-11 | 34.95 | 398.75 | 218.45 | |||
SO58949_1 | 5D37-48BC-B5 | PO11165128759 | 19 | 291 | 475 | 586 | 6 | 2023-09-15 | 125.98 | 3.15 | 2023-09-03 | 3 | 26.18 | 1 | 125.98 | 1 | SO58949 | 2023-09-10 | 10.08 | 78.53 | 41.99 | |||
SO58949_2 | 5D37-48BC-B5 | PO11165128759 | 19 | 291 | 476 | 586 | 6 | 2023-09-15 | 251.96 | 6.30 | 2023-09-03 | 6 | 26.18 | 1 | 251.96 | 2 | SO58949 | 2023-09-10 | 20.16 | 157.06 | 41.99 | |||
SO58949_3 | 5D37-48BC-B5 | PO11165128759 | 19 | 291 | 474 | 586 | 6 | 2023-09-15 | 125.98 | 3.15 | 2023-09-03 | 3 | 26.18 | 1 | 125.98 | 3 | SO58949 | 2023-09-10 | 10.08 | 78.53 | 41.99 | |||
SO58949_4 | 5D37-48BC-B5 | PO11165128759 | 19 | 291 | 359 | 586 | 6 | 2023-09-15 | 6884.97 | 172.12 | 2023-09-03 | 5 | 1251.98 | 1 | 6884.97 | 4 | SO58949 | 2023-09-10 | 550.80 | 6259.91 | 1376.99 | |||
SO65198_1 | 8423-4A3C-93 | PO11165196805 | 19 | 291 | 474 | 586 | 6 | 2023-12-15 | 167.98 | 4.20 | 2023-12-03 | 4 | 26.18 | 1 | 167.98 | 1 | SO65198 | 2023-12-10 | 13.44 | 104.71 | 41.99 | |||
SO65198_2 | 8423-4A3C-93 | PO11165196805 | 19 | 291 | 475 | 586 | 6 | 2023-12-15 | 41.99 | 1.05 | 2023-12-03 | 1 | 26.18 | 1 | 41.99 | 2 | SO65198 | 2023-12-10 | 3.36 | 26.18 | 41.99 | |||
SO71825_1 | 13EC-4324-90 | PO11165197222 | 19 | 291 | 476 | 586 | 6 | 2024-03-16 | 335.95 | 8.40 | 2024-03-04 | 8 | 26.18 | 1 | 335.95 | 1 | SO71825 | 2024-03-11 | 26.88 | 209.41 | 41.99 | |||
SO71825_2 | 13EC-4324-90 | PO11165197222 | 19 | 291 | 483 | 586 | 6 | 2024-03-16 | 288.00 | 7.20 | 2024-03-04 | 4 | 44.88 | 1 | 288.00 | 2 | SO71825 | 2024-03-11 | 23.04 | 179.52 | 72.00 | |||
SO71825_3 | 13EC-4324-90 | PO11165197222 | 19 | 291 | 359 | 586 | 6 | 2024-03-16 | 2753.99 | 68.85 | 2024-03-04 | 2 | 1251.98 | 1 | 2753.99 | 3 | SO71825 | 2024-03-11 | 220.32 | 2503.96 | 1376.99 | |||
SO71825_4 | 13EC-4324-90 | PO11165197222 | 19 | 291 | 474 | 586 | 6 | 2024-03-16 | 251.96 | 6.30 | 2024-03-04 | 6 | 26.18 | 1 | 251.96 | 4 | SO71825 | 2024-03-11 | 20.16 | 157.06 | 41.99 | |||
SO71825_5 | 13EC-4324-90 | PO11165197222 | 19 | 291 | 475 | 586 | 6 | 2024-03-16 | 125.98 | 3.15 | 2024-03-04 | 3 | 26.18 | 1 | 125.98 | 5 | SO71825 | 2024-03-11 | 10.08 | 78.53 | 41.99 |
Generated 2024-05-03 03:33:35.212 UTC